• 专利附录
  • 专利说明
  • 权利要求
  • 类似技术
  • 同族专利
  • 引用文献
  • 法律状态
  • 优先权
    • 专利摘要:
    Figure 1 Méthode de création de fiche de sécurité de substances chimiques. Méthode de production de fiche de sécurité SDS dans laquelle les données nécessaires à la création et l’impression de ces fiches SDS sont recopiées depuis au moins une base de données BD héritées dans une base de données locales BDL. Ces données nécessaires sont ensuite héritées par des familles R et/ou sous-familles SR et/ou mélange M sous forme de pointeur. Enfin, les produits P héritent des données des familles R et/ou sous-familles SR et/ou mélange M pour créer et imprimer les fiches de sécurité SDS. Figure 1 Method for creating chemical safety data sheets. A method of producing an SDS security card in which the data necessary for creating and printing these SDSs are copied from at least one legacy BD database into a local BDL database. This necessary data is then inherited by families R and / or SR sub-families and / or M mixture as a pointer. Finally, the products P inherit data from the families R and / or sub-families SR and / or mixture M to create and print the SDS security cards.
    公开号:BE1023084B1
    申请号:E2015/5595
    申请日:2015-09-25
    公开日:2016-11-18
    发明作者:Michel HEMBERG；Thierry LEVINTOFF；Dirk Stevens
    申请人:Lisam Systems；
    IPC主号:
    专利说明:

    The invention relates to the creation of safety data sheets (SDS) for chemicals and products.
    STATE OF THE ART [0002] The management of regulatory data relating to chemical substances and chemical mixtures, the classification according to its danger of a mixture on the basis of the data of the substances which compose it, the automation of the generation of legal documents in the different languages based on the classification of a product and finally, the updating and printing of a very large number of SDS forms in a very short time, are important problems for chemical manufacturers.
    In fact, the data used must be updated regularly, generally once a quarter, for all the chemicals in a company. These tasks are expensive in time and money. When the number of chemicals is high, it is virtually impossible to perform this task manually in writing or by computer because all data and SDS of all products must be updated simultaneously to comply with national and international laws.
    Various management methods have been developed to manage these data and create the SDS. For example, the method proposed by Infodyne consists of: • provision of a database; • assisted drafting of SDS from the database and editing of a SDS compliant with legislation; • systematic updating of the database; • automatic selection of relevant items in a library provided by Infodyne; • Instant translation of regulatory phrases into 30 languages; • memorization of user-generated sentences with direct connection to the relevant paragraphs and, if necessary, attachment to a specific substance; • online printing of SDS or export to another computer system; • management of customer / SDS links with traceability, history and recovery; • printing instructions in writing for the transport of dangerous goods; • written instructions; • publication of additional documents (hygiene and safety notices, documents for occupational medicine, biocidal declarations, INRS declarations, allergenic fragrance declarations, technical data sheets for flavorings and other personalized documents). Nevertheless, this method has the disadvantage of using only one database. GHS (Global Harmonized System) regulations at the UN level require standardization of chemical risk management. To enable the chemical industries to centralize their regulatory departments worldwide, it is necessary that the software solution be capable of handling the particularities of the different regions. For this, it is necessary to work with several regulatory databases. For example, the toxicity characteristics to be considered may vary from country to country. It can also be mentioned that some federations like EIGA provide specific data to their members to ensure that they use the same reference data. The method proposed by Infodyne does not allow efficient management of multiple databases. The method also does not allow to effectively and simply ensure the traceability of information from several separate databases, but this characteristic is fundamental for the chemical industry and necessary for the management and creation of safety data sheets taking into account local or regional particularities. SUMMARY OF THE INVENTION [0004] According to a first aspect, one of the objects of the present invention is to provide a method for producing SDS security data sheets which uses at least one database, and preferably several databases of data bases. ensuring effective data traceability. This traceability is a fundamental characteristic and necessary for the creation of safety data sheets taking into account the local or regional particularities. In addition, the method according to the invention makes it possible to use data relating to the various aspects required at regional and international level for the creation of SDS security card.
    This method of producing security data sheets is implemented in a network comprising at least one database hosted by at least one service provider, a remote server and at least one local server. The remote server is connected to the service provider and the local server by connections. The data base (s) comprise information on a plurality of entities, said entities being characterized by first identifiers, IDe, unique and comprise a plurality of information fields characterized by second unique IDc identifiers. The method includes the steps: a. establishing a list of entities and information fields needed by a local server for the production of at least one security record (SDS); b. copy by the remote server on the local server of the part or parts of the at least one database listed in step a; vs. creating at least one set of products having the same values of at least one information field; d. creating a link between the at least one set of products and at least a portion of the copy of the at least one database, said link being established according to an inheritance mechanism comprising: 1. creating a daughter entity comprising second identifiers IDc of fields; 2. creating at least one pointer pointing to the information fields of at least one parent entity contained in the copy of the at least one database of the local server; e. creating a security card of a product comprising: 1. inheritance of information fields from at least one daughter entity; 2. creation of security card; f. printing of the security card; steps that can be repeated, steps a, c and d can be performed once.
    [0005] Preferably, product sets having the same values of at least one information field are taken into account to reduce the volume of data and to promote traceability. For this purpose, the local server comprises data relating to chemical substances and mixtures and step e comprises an additional step: comparison of the information fields with the data relating to chemical substances and chemical mixtures, this step being carried out after step e) 1 and before step e) 2.
    Preferably, the local server comprises data relating to the regulation and classification of dangerous substances and chemical mixtures and wherein step e further comprises the step of: comparing the information fields with the data. relating to the classification of the dangerousness of a mixture or a chemical substance, this step being carried out after step e) 1 and before step e) 2.
    [0007] Preferably, the local server comprises data relating to local regulations and step e) 2 consists of: comparison of the information fields with local regulations; creation of local SDS; this step being performed after step e1.
    A second purpose of the method according to the invention is to automatically translate the safety data sheet taking into account local regulations and legislation. For this, the local server includes translations of regulatory headings and keywords. These translations and keywords are inherited and the method according to the invention comprises the additional step: automatic translation of the SDS security card, this step being performed after step e.
    Preferably, the method according to the invention makes it possible to create local documents, this step being carried out after step e.
    Brief Description of the Drawings [0010] These and other aspects of the invention will be clarified in the detailed description of particular embodiments of the invention, reference being made to the drawings of the figures, in which: FIG. 1 shows a principle diagram of method 100 according to the invention; Fig.2 shows an example of an entity; Fig.3 shows an illustration of the inheritance mechanism; Fig.4 shows a multilevel inheritance mechanism; FIG. 5 shows an example of an extract of a security card;
    The drawings of the figures are not to scale. Generally, similar elements are denoted by similar references in the figures. The presence of reference numbers in the drawings can not be considered as limiting, even when these numbers are indicated in the claims.
    DETAILED DESCRIPTION OF PARTICULAR EMBODIMENTS OF THE INVENTION [0011] FIG. 1 shows a principle diagram of the method 100 according to the invention. The method is implemented within a network 110 that can be divided into three parts interconnected by network connections. For example, these network connections are internet connections, other types of connection can be envisaged. The method 100 according to the invention makes it possible to create, print and automatically update SDS (safety data sheet) data sheets for P products.
    The first part of the network 120 comprises at least one database BD1 hosted by at least one service provider FS1. Preferably, one can have n database: BD1 to BDn hosted at k service providers: FS1 to FSk. These databases BD include information on a plurality of entities 210 (see Figure 2). An entity 210 is defined as a chemical substance, a mixture or an article. The entities 210 comprise a plurality of information fields 220 (see FIG. 2) of bases necessary for the creation of SDS security cards. This information is, for example, information on the composition of substances, legal data on the exposure of workers to chemicals (by country), standard phrases for translating documents (by language), information on the overall system harmonized classification and labeling system (GHS Globally Harmonized System of Classification and Labeling of Chemicals), lists of banned or authorized products (by country, by sector: food industry, petrochemical industry, ...), information on the conditions of transport, toxicity, dangerousness, ...
    Preferably, each entity is identified by a first identifier IDe. Preferably, each information field is identified by a second identifier IDc.
    Preferably, the data are text data, images, digital fields, lists,. Preferably, at least some of the data in the BD databases depend on local or regional legal or regulatory specifications.
    Preferably, these databases BD are updated by FS service providers. Preferably, these updates are, in general, quite rare. Alternatively, updates can be daily, weekly, monthly, yearly,.
    Alternatively, the centralized service provider FSC includes a database BD.
    The second part of the network 130 includes the remote server hosted at the centralized service provider FSC. Preferably, the remote server provides the link between the FS service providers comprising the databases BD and the third part of the network 140 comprising at least one local client server C. Preferably, the centralized service provider FSC performs a first treatment T1 data which consists in selecting in BD databases of the FS service providers at least one entity 210 useful to a client C and copy this at least one entity 210 in a local database BDL client C. The purpose of this T1 processing is to reduce the amount of information stored in the C client, which allows the use of a standard desktop computer as a means of storage. The second purpose of this local copy is to allow client C to continue updating its SDS when the connection with the centralized service provider FSC is interrupted. The third goal is to offer the customer the possibility to postpone updates of his local database BDL and thus to preserve old data.
    The third part of the network 140 comprises the local server of the client C. This part comprises a local database BDL consisting of at least one entity 210 of at least one database BD of at least one provider of data. FS services recopied by the centralized service provider FSC. Preferably, the BDL includes data relating to the chemical substances and mixtures used by the customer C, to their regulation and to the classification of the dangerousness of these chemical substances and mixtures.
    Preferably, the data of this local database BDL are processed during the processing T2 to create families. A family F is defined as a subset of data from the local database BDL and common sets of products P. For example, a family F consists of product characteristics with the same toxic risks, or presenting the same transport conditions, or the same physical conditions (liquid, solid, gaseous), ...
    Preferably, the families F are defined locally in the client C and depend on the products P manufactured, processed or used by the client C. Their definition may possibly be changed.
    Preferably, a family F is linked, during the processing T2, to at least one field 220 of at least one entity 210 of the local database BDL.
    An SDS security record is generated by the T3 processing which integrates the information of at least one family F into the fields required for the creation of an SDS security record. Examples of these items are: company and product identification, risk identification, composition, first aid measures, fire response, spill response measures, storage, protective equipment necessary for handling the product, physical and chemical properties, reactivity and stability, toxicological information, ecological information, transport information, regulatory information, etc.
    Preferably, an SDS security card is produced by combining the information of several families F.
    Preferably, the F family data can be cross-referenced with information about the chemical M mixtures that depend on the final P products.
    Preferably, families F can be divided into subfamilies: for example the family F of the compounds in powder form can be divided into two sub-families: explosive and non-explosive powders.
    Preferably, the T3 processing makes it possible to create the SDS product sheets from the data of the families F, sub-families and mixtures M.
    Preferably, the T3 treatment also takes into account the regulatory phrases required by the various national and international legislations. The fields of the SDS product sheets: fire brigade instructions, doctor instructions, toxicity, transport condition,. are thus filled automatically.
    Preferably, the client C can also define its own fields, which adds flexibility.
    Preferably, created SDS product sheets are printed automatically.
    These sheets are updated regularly, and preferably once a quarter. The client C can be free to refuse the update and can thus maintain control over the data it uses. For example, when the regulation changes, it can decide when it changes to the new version and so it can decide when the local database BDL is updated.
    Preferably, the SDS security cards can also be translated automatically. For this, the local server includes translations of regulatory headings and keywords. These translations and keywords are inherited when creating SDS security cards.
    Preferably, local and global documents can be created from the families F. For example, if there are several different national or regional regulations for the same product P, several safety data sheets are produced taking into account these national regulations or regional. Preferably, when there is more than one data for the same field, the origin of these data is traceable.
    Figure 3 illustrates the inheritance mechanism of the method 100 according to the invention. This mechanism simplifies the creation of SDS security cards and makes it automatic. This mechanism is involved in T2 and T3 treatments.
    Preferably a family F is defined as an array. Preferably, this table is of variable size and the size can vary dynamically. This table comprises at least one pointer which points to at least one second identifier of information fields 220 IDc1 contained in at least one entity 210 identified by its first IDel identifier, said entity being included in the local database BDL.
    Preferably, the array of pointers that point to several IDC1, IDc2 information field IDs contained in several entities 210 identified by their first identifier IDe1, Ide2, said entities being included in the local database BDL.
    Preferably, the links between the families F and the sub-families are made in the same way. Preferably, the links between families F, sub-families, mixtures M, and products P are made in the same way.
    As a result, the families F and products P do not contain stricto sensu data but inherit from the local database BDL. The information fields of a daughter entity of an F family can inherit data from a parent field of an entity. Preferably, the different fields of a family F can inherit from several parent entities.
    When the fields 220 of the parent entity 210 are updated, the fields of the family F daughter are also directly updated.
    Alternatively, the P products can inherit data directly contained directly in the local database BDL.
    The updating of the SDS security cards can be done automatically thanks to the inheritance mechanism. Preferably, it is possible to break the parent-child inheritance.
    Preferably, the mixing data M can be used for the creation of product P. For example, when a product P consists of several chemical substances (mixture), the characteristics of these substances contained in different families F are inherited.
    In another example, a new product P2 derived from another product P1 can be created and the work of creating SDS security card for the new product is greatly simplified because the new product P2 can inherit its data from the old product P1. In other words, changing P1 causes a change of P2. For example, in the paint industry, two products may differ only in color and be presented as two separate commercial products. In this case, one of the two products will inherit all its characteristics from the other product except its color which it will inherit, for example, from another family.
    Figure 4 shows a mechanism of inheritance on several levels of the method 100 according to the invention. When creating an SDS security card, the information fields are inherited from a family F, a subfamily SF and / or a composition of mixture M. Preferably, the inheritance mechanism can be done between several levels. that is, an SDS security card may inherit part of its data from a family F, another part from a subfamily SF, and / or another part from a mix composition M, and / or another part from the local BDL database.
    Preferably, a subfamily SF may inherit a portion of its data from a family F, and / or another portion from a subfamily SF and / or another portion from the local database BDL.
    Preferably, multi-level inheritance takes into account the regional specificities of GHS and classify P products for different regions. Preferably, a client C can choose the local specificities that it must respect.
    For example, Figure 4 illustrates copying from BD1 BD2 BD3 databases of FS service providers by the central service provider FSC into the local database BDL. The copied information fields are identified by their second identifiers: IDc1, IDc2 belonging to the entities 220 identified by their first identifiers: IDe1, IDe2, IDe3, IDe4, IDe5. The inheritance mechanism is illustrated by the arrows which represent the pointers that point from the families F, subfamilies SF, mixtures M and products P to the local database BDL and / or the families F, subfamilies SF, For example, the SF1 subfamily inherits its data from the local BDL database and from the F1 and F2 families.
    Preferably, multi-level inheritance provides traceability of information and multiple database management.
    Figure 5 shows extracts of an SDS security card. For example, the security card includes product and manufacturer identification information. It also includes pictograms of hazards, information on the composition, first aid measures, measures in the event of fire, ... Preferably, each section contains more precise information. For example, in the section of measures in the event of fire, one finds information on the type of extinguisher to use.
    Thanks to the method of the invention it is possible to reduce the amount of information stored in the client C, which allows the use of a standard desktop computer as a storage medium. It is also possible to allow client C to continue updating its SDS when the connection with the centralized service provider FSC is interrupted. Finally, it is possible to allow the client C to postpone updates to its local database BDL and thus retain old data.
    The present invention has been described in relation to specific embodiments, which have a purely illustrative value and should not be considered as limiting. In general, the present invention is not limited to the examples illustrated and / or described above. In particular, the invention also relates to combinations of the technical characteristics of the embodiments described above. The use of the verbs "to understand", "to include", "to include", or any other variant, as well as their conjugations, can in no way exclude the presence of elements other than those mentioned. The use of the indefinite article "a", "an", or the definite article "the", "the" or "the", to introduce an element does not exclude the presence of a plurality of these elements. The reference numerals in the claims do not limit their scope.
    In summary, the invention can also be described as follows. A method of producing an SDS security card in which the data necessary for creating and printing these SDSs are copied from at least one legacy BD database into a local BDL database. This necessary data is then inherited by families F, and / or sub-families SF, and / or mixture M in the form of a pointer. Finally, the products P inherit data from families F, and / or sub-families SF, and / or mixture M to create and print the SDS security forms.
    权利要求:
    Claims (6)
    [1]
    claims
    A method for producing a security card (SDS) implementing a network (110) comprising at least one database (BD) hosted by at least one service provider (FS), a remote server and at least one server local, the remote server being connected to the at least one service provider and the at least one local server by connections, the at least one database comprising information on a plurality of entities, said entities (210 ) being characterized by first identifiers, IDe, unique and comprising a plurality of information fields (220) characterized by second unique IDc identifiers; the method comprising the steps: g. establishing a list of entities (210) and information fields (220) required by a local server for producing at least one security record (SDS); h. copying by the remote server to the local server of the at least one database (BD) listed in step a; i. creating at least one set of products (P) having the same values of at least one information field (220); j. creating a link between the at least one set of products (P) and at least a portion of the copy of the at least one database (BD), said link being established according to an inheritance mechanism comprising: 1. creating a daughter entity comprising second IDc IDs of fields (220); 2. creating at least one pointer pointing to the information fields (220) of at least one parent entity (210) contained in the copy of the at least one database (BD) of the local server; k. creating a security record (SDS) of a product (P) comprising: 1. inheritance of information fields (220) from at least one daughter entity (210); 2. creation of safety data sheet (SDS); l. printing of safety data sheets (SDS); steps that can be repeated, steps a, c and d can be performed once.
    [2]
    2. The method of claim 1, wherein the local server comprising data relating to chemical substances and mixtures (M) and wherein step e further comprises the step of: comparing the information fields with the relative data. chemical substances and chemical mixtures (M); this step being performed after step e) 1 and before step e) 2.
    [3]
    3. Method according to any one of the preceding claims, wherein the local server comprising data relating to the regulation and classification of dangerous substances and chemical mixtures (M) and wherein step e further comprises the step: comparison of the information fields with the data relating to the classification of the dangerousness of a mixture or a chemical substance; this step being performed after step e) 1 and before step e) 2.
    [4]
    The method of any of the preceding claims, wherein the local server includes local regulatory data and wherein step e) 2 comprises: comparing information fields with local regulations; creation of local SDS; this step being performed after step e1.
    [5]
    5. Method according to any one of the preceding claims, wherein the local server comprising translations of the regulatory headings and keywords and further comprising the step: automatic translation of the SDS security card; this step being performed after step e.
    [6]
    The method of any one of the preceding claims, further comprising the step of: creating local documents; this step being performed after step e.
    类似技术:
    公开号 | 公开日 | 专利标题
    US11182490B2|2021-11-23|Obfuscation of user content in user data files
    CN101777057B|2012-09-26|Methods and systems for storing customer fields for multiple tenants in multi-tenant database system
    Steen2011|Retractions in the scientific literature: is the incidence of research fraud increasing?
    Rauschmayer2014|Speaking JavaScript: an in-depth guide for programmers
    US7085752B2|2006-08-01|Customization of metadata describing objects in a computing environment
    US7711688B2|2010-05-04|Customization of process logic in a software system
    EP1471425A2|2004-10-27|Extensible customization framework for a software system
    CN101263454A|2008-09-10|Extensible XML format and object model for localization data
    US20050004922A1|2005-01-06|Device, System and Method for Converting Specific-Case Information to General-Case Information
    US20060271379A1|2006-11-30|Intellectual property analysis and report generating system and method
    Kahani et al.2016|The problems with eclipse modeling tools: a topic analysis of eclipse forums
    US20180276402A1|2018-09-27|Data loss protection for structured user content
    US20060143591A1|2006-06-29|Extensibility framework for developing front office | workflow automation components
    Odersky et al.2011|Scala
    BE1023084B1|2016-11-18|Method of creating chemical safety data sheets
    US8725754B2|2014-05-13|Method and system for modeling data
    Kasim et al.2016|E-code checker application
    Baum et al.2018|Suspected synthetic cannabinomimetic intoxication: case series and review
    Ed-Douibi et al.2017|A UML profile for OData web APIs
    Driller et al.2021|Retrospective review of nicotine exposures in California from 2012 to 2018 and analysis of the impacts of e-cigarette regulations
    Dey et al.2022|LAGOON: An Analysis Tool for Open Source Communities
    Lampa et al.2017|RDFIO: extending Semantic MediaWiki for interoperable biomedical data management
    Dallavia et al.2015|Internal reporting with XBRL global ledger: enhance internal decision making with better integrated, more detailed, and timelier reports
    Mora et al.2018|Semi-automatic Extraction of Plants Morphological Characters from Taxonomic Descriptions Written in Spanish
    Çabuk2019|A note on the contact between Kurmanji Kurdish and Turkish at lexical and morphological level
    同族专利:
    公开号 | 公开日
    引用文献:
    公开号 | 申请日 | 公开日 | 申请人 | 专利标题
    法律状态:
    优先权:
    申请号 | 申请日 | 专利标题
    [返回顶部]